package com.fs.groupSeven.Dao;

import com.fs.groupSeven.pojo.*;
import org.apache.ibatis.annotations.Param;

import java.sql.Date;
import java.util.List;

public interface TeachingInformationDao {
    List<TeachingInformation> queryAllByClassName(String classname);
    List<TeachingInformation> queryAllByClassName2(String classname);
    TeachingInformation queryOneByCode(String code);
    List<MyTeacherTest> queryAllBySubjectId(Integer sid);
    List<MyClassRoomTest> queryClassRoom();
    List<MySubjectTest> querySubject(Integer college_id);
    String queryClassRoomByClassId(Integer class_id);
    String querySubjectBySid(Integer subject_id);
    List<String> queryClassName();

    int updateBySubject(@Param("oldName") String oldName, @Param("name") String name,@Param("duration") String duration);
    int updateBySchedule(@Param("time_on") String time_on, @Param("time_off") String time_off, @Param("identifier") String identifier);
    int updateByClassroom(@Param("class_id") Integer class_id, @Param("classroom_id") Integer classroom_id);
    int updateByOldClassroom(@Param("classroom_id") Integer classroom_id);
    int deleteClassSubject(@Param("class_id") Integer class_id, @Param("subject_id") Integer subject_id);
    int deleteSchedule(@Param("class_id") Integer class_id, @Param("subject_id") Integer subject_id);
    int insertClassSubject(@Param("class_id") Integer class_id, @Param("subject_id") Integer subject_id);
    int insertSchedule(@Param("class_id") Integer class_id, @Param("subject_id") Integer subject_id,@Param("time_on") Date time_on, @Param("time_off") Date time_off, @Param("identifier") String identifier);
}
